Microsoft Excel Quiz
IT Level 1
Sign in to Google to save your progress. Learn more
What is your name? *
A ________________ consists of a grid made from columns and rows? *
1 point
What is not a basic part of a spreadsheet? *
1 point
In a spreadsheet, the ________ is defined as the horizontal space that is going across the window. *
1 point
In a spreadsheet, the __________ is defined as the vertical space that is going across the window. *
1 point
_____________ are used to designate each column's location. *
1 point
___________ are used to designate each row's location. *
1 point
In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect. *
1 point
 In Excel, a _________________ is a value that is not calculated. *
1 point
Name the cell in the picture below. *
1 point
Captionless Image
In the spreadsheet below, which of the following is  NOT an example of a label? *
1 point
Captionless Image
 What is the correct formula for the following:  you work for 23 hours and make $5.36 an hour, how much do you make? *
1 point
Captionless Image
In the spreadsheet, _____________ are equations that can perform calculations, return information, manipulate the contents of other cells and test conditions. *
1 point
The _________ function adds all of the indicated cells together and divides by the total number of cells. *
1 point
In a spreadsheet, what are the three types of data that can be found in a cell? *
1 point
In Excel, what is the symbol for multiplication? *
1 point
In Excel, what is the symbol for division? *
1 point
In Excel, what is the symbol for addition? *
1 point
In Excel, what is the symbol for subtraction? *
1 point
You can complete a cell entry by pressing: *
1 point
An example of a range address: *
1 point
When you start to select a range of cells, you will see a thick white, cross-shaped pointer called a ________________. *
1 point
Microsoft Excel is a powerful __________________ *
1 point
An Excel Workbook is a collection of____________ *
1 point
A single working area in a spreadsheet file is called ____________ *
1 point
A workbook is a _________________ *
1 point
How do you rearrange the data in ascending or descending order? *
1 point
To select an entire column in MS-EXCEL, press? *
1 point
To select an entire row in MS-EXCEL, press? *
1 point
In Excel spreadsheet, ###### means: *
1 point
Which key do you press to group two or more nonadjacent worksheets? *
1 point
On an Excel sheet, the active cell is indicated by ____. *
1 point
If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total? *
1 point
Which formula below will add the value of B2 to the value of C3 *
1 point
What is the function of the word '=SUM' at the beginning of an Excel spreadsheet formula? *
1 point
Using a cell address in a formula is known as: *
1 point
A selection of multiple cells is called a *
1 point
In which view can you see the header and footer areas of a worksheet *
1 point
Which of the following statements is TRUE about Excel spreadsheets?  (I) A spreadsheet is a system software used to produce financial statements  (II) Each worksheet has a tab that cannot be renamed  (III) A new workbook contains three worksheets, then more can be added  (IV)To repeat data in a series of cells use the fill handle. *
1 point
The picture below is an example of a_____________ *
1 point
Captionless Image
The picture below is an example of a_____________ *
1 point
Captionless Image
The picture below is an example of a_____________ *
1 point
Captionless Image
The section to the right in the picture below is an example of a_____________ *
1 point
Captionless Image
The selection made at the top of the picture below, which was used to plot this chart, is an example of a_____________ *
1 point
Captionless Image
To create an oblique column heading, we change the _________of the text in the cell. *
1 point
The arrangement of data into a table form is called____________________ *
1 point
Submit
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms