WorksheetsExcel Basics
Total questions: 20
Worksheet time: 15mins
Name
Class
Date
1.
1) Study the highlighted cells in the image below and identify which of the following represents the correct cell address for these cells:
a)
a) The cell reference for the selected cells is B:21, C:28, D:22, E:26 and F:25.
b)
b) The cell reference for the selected cells is row 15, column F
c)
c) The cell reference for the selected cells is F4:F5
d)
d) The cell reference for the selected cells is B15:F15
2.
2) What is the purpose of the Quick Access Toolbar (circled in orange in the image below)?
a)
a) It provides shortcuts to functions you may use frequently as well as functions that may not be on the Ribbon.
b)
b) You can only use it to save, redo and undo, create new documents, open documents and print.
c)
c) It displays functions you have recently used as well as frequently used functions.
d)
d) None of the above options are correct.
3.
3) Which of the following functions are you likely to find under the Insert tab on the Ribbon?
a)
a) Insert a page break.
b)
b) Insert a formula.
c)
c) Insert a table.
d)
d) Insert track changes.
4.
4) Study the orange circled area of the worksheet in the image below. Which of the following best describes the function of this area?
a)
a) The Name Box displays a name given to a cell or set of cells.
b)
b) The Name Box reflects the contents of the first cell that is selected in a range.
c)
c) The Name Box gives you options for duplicating the selected cells.
d)
d) All of the above options are correct.
5.
5) The Formula Bar is the block located above the grid in a worksheet and preceded by the letters fx. Which of the following comments about the Formula Bar is NOT correct:
a)
a) The Formula Bar is only used to create formulas by pressing the fx located to the left of the box.
b)
b) The Formula Bar contains the contents of the cell you have selected.
c)
c) You can type numbers or text directly into the formula bar.
d)
d) You can edit words or numbers contained in selected cells in the Formula Bar.
6.
6) What happens when you press the icon circled in orange in the image below?
a)
a) It moves the worksheet up and hides rows.
b)
b) It minimizes the Ribbon.
c)
c) It opens another part of the Ribbon.
d)
d) It detaches the Ribbon from the worksheet and allow you to move it around.
7.
7) Study the image below this question. What is the purpose of the two words circled in orange?
a)
a) These represent the names of the individual workbooks you have saved. If you click on the "Sales 2" tab it will open this workbook.
b)
b) These reflect a selected range of cells in the worksheet. If you click on "Sales 2" it will take you to the selected cell.
c)
c) These represent worksheets that have been created in the workbook. If you click on them they will take you to the different sheets.
d)
d) This is the Name Box and represents named ranges in the worksheet. If you click on "Sales 2", you can rename the range.
8.
8) Study the section of a worksheet in the image below. What is the cell address of the cell containing the word "Qtr3"?
a)
a) The cell address is D1
b)
b) The cell address is E 5
c)
c) The cell address is D 4
d)
d) The cell address is D 5
9.
9) Which of the following functions is NOT associated with the Review Tab on the Ribbon?
a)
a) The spelling checker.
b)
b) The sort data function.
c)
c) The comment function.
d)
d) The track changes function.
10.
10) Study the image below this question. The Quick Access Toolbar is appearing below the Ribbon (circled in orange). How would you go about moving it back to its position above the Ribbon?
a)
a) This is a default setting with some versions of Excel. You need to reinstall Excel to fix this issue.
b)
b) You can move the toolbar back up to its position by holding down the left mouse button and dragging it into position.
c)
c) If you close the workbook and reopen it again, the toolbar will move back to its original position.
d)
d) If you right click on it and select "Show Quick Access Toolbar above the Ribbon" it will move back.
11.
11) Study the screenshot above. You will note Row 2 is selected. What happens when you press Ctrl+Shift++(plus) with a row selected?
a)
a) The SUM of the values in the row is calculated.
b)
b) The contents of the row is copied.
c)
c) A new row is inserted above the selected row.
d)
d) A new column is inserted to the right of the selected row.
12.
12) What is the keyboard shortcut to select a row of active cells?
a)
a) Shift + Spacebar
b)
b) Ctrl + Spacebar
c)
c) Shift + End
d)
d) Ctrl + End
13.
13) Most workbooks in Excel contain multiple worksheets (noted on the tabs at the bottom right-hand side of the Excel screen). Which of the following is the keyboard shortcut to for switching between worksheet tabs?
a)
a) Alt+Tab
b)
b) Alt+PgDn/PgDn
c)
c) Ctrl+UpArrow/DownArrow
d)
d) Ctrl+PgDn/PgUp
14.
14) What happens when you select cells and press Ctrl+2?
a)
a) Text in the selected cells are underlined.
b)
b) Bold formatting is applied to the text in the selected cells.
c)
c) Italic formatting is applied to the text in the selected cells.
d)
d) A duplicate of the selected cells will be inserted directly below the selection.
15.
15) What is the keyboard shortcut for reversing (undoing) your last action?
a)
a) Ctrl+U
b)
b) Ctrl+X
c)
c) Ctrl+Y
d)
d) Ctrl+Z
16.
16) Which shortcut key combination can be used to insert the current date into a cell?
a)
a) Ctrl+D
b)
b) Ctrl+; (semicolon)
c)
c) Ctrl+Shift+; (semicolon)
d)
d) Ctrl+Shift+D
17.
17) What happens when you press the shortcut combination Ctrl+i while you have cells, containing content such as text or numbers, selected?
a)
a) This italicizes the selected content.
b)
b) This launches the Excel Information and Help dialogue box.
c)
c) This inserts a new row or column depending on the selection.
d)
d) This hides the selected cell range.
18.
18) What is the shortcut key to save a workbook?
a)
a) Ctrl+Enter
b)
b) Ctrl+Shift+S
c)
c) Alt+S
d)
d) Ctrl+S
19.
19) Selecting multiple columns, especially if they run into the hundreds, can take a long time if you do this the manual way by using your mouse. What is a shortcut for quickly selecting a range of contiguous columns?
a)
a) Select the first column. Hold down Ctrl and press the right arrow on the keyboard.
b)
b) Select the first column. Hold down Ctrl and drag the mouse cursor towards the right.
c)
c) Select the first column. Hold down Shift and press the right arrow on the keyboard.
d)
d) All of the above options are correct.
20.
20) Study the screenshot of the Format Cells dialogue box above. Which of the following shortcut combinations launches this dialogue box?
a)
a) Ctrl+1
b)
b) Ctrl+Shift+F
c)
c) Ctrl+F
d)
d) Ctrl+F1
100 %
