Font size
WorksheetsExcel Intermediate Test 2
Total questions: 15
Worksheet time: 8mins
The intersection of a row and a column is called a ________.
cell
chart
sum
worksheet
A group of cells is called a ________.
chart
cell cluster
multicell
cell range
You can click the tabs at the bottom of a workbook to switch between ________.
permissions
worksheets
formulas
number formats
True or False: You can use the function of daily changeable date by using the Following function =now()
True
False
Which of the formulas below are valid? Select all that apply.
=R2*D2
A3+100
=5B+6B
=F2+F3+F4-53
What are the shortcut keys for Printing?
ALT and S
CTRL and P
ALT and =
CTRL and =
You can link 2 sheets in the same Excel sheet or Outside the Excel sheet file by using the Following Function.
Pivot Table
Hyperlinks
=Now()
Data Validation
What are the keyboard shortcut keys to edit formula in a cell?
F2
F4
CTRL + 1
CTRL + F
What are the keyboard shortcut keys to create a table?
ALT + T
ALT + N + C
ALT + N + V
ALT + N + T
If you want to Merge and Center the Cell, you can select the relevant function below:-
Center
Merge & Center
Bold
Underline
If you want to creat list of Data Validation, You will use the following Function: -
Data Validation
Formating
Painting
Merge and Center
Which button allows you to copy cell formats from one cell to another?
Enter
Autofit
Format painter
Esc
You can complete a cell entry by pressing:
Enter
Tab
Shift+tab
An arrow key
All of above
All formulas in Excel begin with the following symbol.
+
=
/
*
Excel is a program that is used to prepare a
Slide presentation
Spreadsheet
Text document
Database
