excel questions verified source /newest, Exams of Advanced Education

excel questions verified source /newest

Typology: Exams

2025/2026

Available from 06/07/2026

tizian-mwangi
tizian-mwangi 🇺🇸

4.1

(8)

29K documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1
/
5
excel questions verified source /newest
1.
In Microsoft Excel, the file you create and edit is called::
a
workbook
2. By default, Excel 2016 files are saved with this extension.: .xlsx
3.
Text in a worksheet that displays a name, a main title, row or
columns titles, and similar descriptive info is called::
a label
4. When you click on a cell to activate it, the cell address appears in::
the name box
5.
When you want to delete characters in a cell to the left of the
insertion point
press:: backspace
6.
A new Excel workbook uses the default theme named::
oflce
7. A rectangular group of cells in Excel is called a:: range
8.
The thin black
plus sign
pointer is
used to:: copy cell contents or complete a
series
9. To quickly select all the cells in a worksheet::
press ctrl + A
10. After you select and cut cells, the cells are temporarily placed::
on the
clipboard
11. In an Excel worksheet, dates and times are:: values
12.
When you want column and row headings displayed whether
you are at the top, bottom, left, or right of the spreadsheet, select::
freeze panes
13.
Use this button to combine two or more cells into one cell
and center the
text over a group of columns.: merge and center
14. A quick way to insert a new column or row is an existing
worksheet is to select a column or row and press:: ctrl + plus sign
15. The default view in Excel is::
normal
16.
This Excel feature allows users to evaluate values and return
a result::
formulas
17.
This symbol alerts Excel that you are entering a formula and
pf3
pf4
pf5

Partial preview of the text

Download excel questions verified source /newest and more Exams Advanced Education in PDF only on Docsity!

1 /

excel questions verified source /newest

  1. In Microsoft Excel, the file you create and edit is called:: a workbook
  2. By default, Excel 2016 files are saved with this extension.: .xlsx
  3. Text in a worksheet that displays a name, a main title, row or columns titles, and similar descriptive info is called:: a label
  4. When you click on a cell to activate it, the cell address appears in:: the name box
  5. When you want to delete characters in a cell to the left of the insertion point press:: backspace
  6. A new Excel workbook uses the default theme named:: oflce
  7. A rectangular group of cells in Excel is called a:: range
  8. The thin black plus sign pointer is used to:: copy cell contents or complete a series
  9. To quickly select all the cells in a worksheet:: press ctrl + A
  10. After you select and cut cells, the cells are temporarily placed:: on the clipboard
  11. In an Excel worksheet, dates and times are:: values
  12. When you want column and row headings displayed whether you are at the top, bottom, left, or right of the spreadsheet, select:: freeze panes
  13. Use this button to combine two or more cells into one cell and center the text over a group of columns.: merge and center
  14. A quick way to insert a new column or row is an existing worksheet is to select a column or row and press:: ctrl + plus sign
  15. The default view in Excel is:: normal
  16. This Excel feature allows users to evaluate values and return a result:: formulas
  17. This symbol alerts Excel that you are entering a formula and

2 / not text:: =

  1. The color-coded editing tool that applies different colors to each cell or cell range included within a formula is called the:: range finder
  2. When a formula contains a typographical error, unnecessary or missing punctuation, incorrect order of arguments, or an incorrect cell reference, it returns:: an error message that begins with #
  3. The Excel tool button that allows you to step through each part of a formula is called:: evaluate formula
  4. When you are creating formulas using a cell location, the default cell refer- ence is:: relative
  5. This type of cell reference does not change when copied and remains in a fixed position during operations:: absolute
  6. A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the $ in front of the column and row addresses, is:: F
  7. In Excel, the acronym "Please Excuse My Dear Aunt Sally" helps the user remember:: order of operations
  8. It is important to remember that Excel calculates these operations before any other are performed:: items in parenthesis
  9. Excel comes with many built-in formulas called:: functions
  10. This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:: autocalculate
  11. This function calculates loan payment amounts when the borrower makes regular payments and the loan has a constant interest rate:: pmt
  12. This useful Excel function evaluates a specified condition or statement and returns one value if the condition or statement is true and another value if it is false:: if
  13. To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:: 3D cell reference

4 /

  1. Imported content in a worksheet that originated in another program or format is called:: external data
  2. An Excel command that recognizes a pattern and duplicates it is:: flash fill
  3. The type of importable document that includes raw data, no formatting, and uses commas or other characters to separate the data into columns and rows is:: a text file
  4. When you import a document into Excel that uses special characters such as commas to separate columns you are importing a:: delimited file
  5. The Microsoft office relational database application that works with Excel to import and export data is called:: access
  6. Website data can be imported into Excel if the data is:: list-type
  7. In an Excel table the first row of the table with unique descriptive titles or labels is called the:: header row
  8. When you apply a predesigned set of built-in format options such as bor- ders, fill colors, and effects for an Excel table you use:: a table style
  9. The process of arranging rows of data in an identified order is called:: sorting
  10. To use an advanced filter in Excel you first need to create a:: criteria range
  11. When you use Excel's subtotal command your list data is formatted as an:: outline
  12. When you need to highlight information in a worksheet by setting different fill colors or font styles for selected cells use:: conditional formatting
  13. The term for specified Excel data that is indicated with a fill color, a horizon- tal bar, or an icon within the cell is:: data visualization
  14. The basic Excel command that uses relational or comparison operators to determine if the value or label in a cell is formatted is:: highlight cells rules

5 /

  1. To sort numerical data from the largest to the smallest value use this sort order:: descending