NEW
Font size
WorksheetsProductivity Tools - MS Excel Part 1
Total questions: 20
Worksheet time: 15mins
Concatenation of text can be done using?
Apostrophe (')
Exclamation (!)
Hash (#)
Ampersand (&)
Which area in an Excel window allows entering values and formulas?
Tittle Bar
Menu Bar
Formula Bar
Standard Tool Bar
The function that lets you add up a range of cells or values.
SUM
AVERAGE
MAX
MIN
To sort names in a worksheet, we can use this button.
Worksheets are made up of rows and columns.
True
False
Numbers down the left side of the spreadsheet.
Rows
Columns
Files
Worksheets
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The letters in Excel represent the ___________?
Rows
Columns
Data
Cells
What is the name given to the intersection of a row and a column in a spreadsheet?
cell
cube
block
square
The cell address of the highlighted cell is __________?
C4
A4
C5
C
A formula in the spreadsheet should always start with....?
a plus sign
an asterisk
a capital letter
an equals sign
Which of these would add up the numbers from A3 to A6?
+(A3:A6)
=(A3:A6)
=(Ave(a3:a6))
=Sum(A3:A6)
Which of these would multiply the numbers from A3 to A6?
*(A3:A6)
=Multiplay(A3:A6)
=A3*A4*A5*A6
=Sum(a3*a6)
A ____ is another name for an equation used in Excel.
Calculation
Template
Sheet
Formula
These are known as________?
workbooks
worksheets
formula bar
cell
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.
Make the cell wider - drag column lines of the letter or double click
Change the number formatting in the cell
Change the font format in the cell
Delete the data and re-type it
Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is quick way for her to do this?
Conditional Formatting
Page Layout
Quick Format
Cell Alignment
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?
=(A1+A2+A3)/4
A1+A2+A3/4
=A1+A2+A3^4
(A1+A2) + A3/4
Which of the following best explains the difference between formatting your spreadsheet as a table and creating a PivotTable?
Formatting as a table will only add color bands to your headers and rows. A PivotTable turns your data into a 3D graph.
Formatting your spreadsheet as a table will format all of your data in a separate worksheet. A PivotTable creates a table within your worksheet.
There is no difference.
Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.
