Excel Fundamentals
If the number 6 is in cell C4, and the number 5 is in cell D5, then the formula: =SUM(C4,D5) would result in
11
If you type =8/2*4+1 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
17
Which of the following cell entries will result in 6?
=3*2 =6*1
To multiply the value in cell B3 times the value in cell E2, you could use the PRODUCT function. Alternatively, you could simply enter
=B3*E2
Which of the following statements are true regarding entering a value in Excel?
A value is data that can be used in a calculation. Values can include numbers, formulas, dates, and similar entries.
Fill-handle cross
Auto fills adjacent cells
When downloading an Apple iCloud Numbers file, some Excel users prefer to download the file in the ___ format to avoid formatting issues.
CSV
As with all Microsoft Office products, using the shortcut ___ opens the print menu.
CTRL + P
Select two methods of opening the Print menu in Excel.
CTRL + P File > Print
For any formula or function in Excel, there should first be a(n) ___ sign in the cell.
Equal (=)
Which of the following are methods of opening the Print menu in Excel?
File > Print CTRL + P
______-clicking the row or column heading and then selecting Hide will hide the row or column.
Right
Which of the following are methods of moving the contents of one cell in Excel to another cell?
Right-click on the cell to open the context menu. Then select Cut. Right-click on the destination cell and select Paste. Click on the cell to make it active, then on the Home tab, in the Clipboard group, select Cut. Then click on the destination cell and click Paste.
Cursor or large cross
Selects menu items or activates cells
If you want to make a numerical entry in Excel that will not interact with another cell, you can make it a label rather than a value. One way to turn a number into a label is to place a(n) Blank______ in front of the number when you enter it into the spreadsheet.
apostrophe (')
Clicking Enter moves the active cell to the one ___ the cell in which the data was entered.
below
A vertical line of cells in Excel is referred to as a
column
The small black cross in the lower right corner of the active cell is called the ___. It allows the user to copy the contents of the active cell into adjoining cells.
fill handle
CTRL+SHIFT+PLUS (+) is the shortcut for adding a row or column in Excel. Using the menu, to add a row, select the row below where you want to add a row, the click Home>Cells>
insert
To remove and replace characters in Excel, one option is to use Find & Select menu. This menu is indicated by a(n) ___ icon.
magnifying glass
To delete a row in Excel, click on any cell in the row and SHIFT + Spacebar to select the row, then CTRL + Minus (−) to delete it. Alternatively, simply ___ on the row heading and select Delete from the context menu.
right-click
If you enter a formula in a cell and Excel returns a series of hashmark symbols (####), this means that ___.
this is not an error value; it simply indicates that the cell's visible width cannot display the result
Which of the following file formats can be opened using Microsoft Excel viewer?
.xlsx .csv
Unfortunately, Excel does not offer a division function or shortcut. To divide two cell values, use the ___ symbol.
/
The number 27 in the cell depicted is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right?
27
Place the following steps in order if you wish to save a Google Docs (Sheets) file as an Excel file. Click Microsoft Excel (.xlsx) Click Microsoft Excel (.xlsx) open choices for ranking Click the Download option open choices for ranking N Open the Google Docs (Sheets) file open choices for ranking Click the File tab
4 3 1 2
If you type = 3 + 12 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
75
If you type =3+12*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
75
What function would you use to display how many entries are made in column A above cell A37?
COUNT
To avoid potential formatting issues, many Excel users choose to save or send spreadsheet files in the ___ format.
Comma-Separated Values (.csv)
To access numerous management options for a column, row, or worksheet in Excel, you can just right-click on the associated header. This opens the ___ menu.
Context
To select non-adjoining cells in a spreadsheet, hold down the __ key while selecting cells.
Control (Ctrl)
The shortcut for saving a file in Excel (and nearly every Microsoft Office product) is
Ctrl + S
The shortcut to Save an Excel file is ___.
Ctrl + S
Most users then use the shortcut, CTRL + F to open the Find and Replace dialog box. Alternatively, you could click Find in the dialog box in the editing group, that is located on the ___ tab.
Home
The MIN function displays the smallest value in a selected range. A shortcut to the MIN function is located in the AutoSum dropdown menu found in the Editing group of the ___ tab.
Home
In the formula =IF(C1>5,"Yes","No"), what does it mean in plain language?
If the number in cell C1 is greater than 5, then type "Yes," if not type "No."
In the Home tab and the Formula tab in Excel, where is a button for AVERAGE found?
In the AutoSum dropdown menu
CTRL + SHIFT + PLUS (+) is the shortcut for adding a row or column in Excel. Using the menu, to add a row, select the row below where you want to add a row, the click Home > Cells > ___.
Insert
Which of the following statements are true regarding an active cell?
It is the cell where the user can input data. It can be identified by the heavy border around the cell. It will be identified by the Name Box.
To display the highest value in a range quickly, use the __ function.
MAX
Which of the following items are used to identify a cell in the cell's address?
Number—Cell's row Letter—Cell's column
Row heading cross
Resizes the row to the left
___ clicking the row or column heading and then selecting Hide will hide the row or column.
Right
If you want to change the name of a downloaded Excel file, it's often easiest to use the _____ option.
Save As
Which of the following statements are correct regarding Excel's Save As option?
Save As allows you to choose where the file will be saved. Save As allows you to change the name of the file.
When removing and replacing unwanted characters from an Excel spreadsheet, you might use the Find & Blank______ menu, found in the Editing group on the Home tab.
Select
To enter data into a cell and then immediately go to the cell to the right, press the Blank______ key.
Tab
In Excel, the freeze cells or panes option is located in Windows group of the __ tab.
View
If the computer you are using does not have Excel and you do not have a access to Microsoft 365, then you can download Microsoft's Excel Blank______ program.
Viewer
By default, when a number is entered into a cell, it becomes a value that interacts with formulas or values. To keep the number from interacting, type an apostrophe in front so that it becomes ___.
a label
The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n) Blank______.
cell
To select nonadjoining cells in a spreadsheet, hold down the __ key while selecting cells.
control (Ctrl)
Because it indicates the beginning of a function or a formula, the most important symbol in Excel is the Blank______ sign.
equals (=)
In order to emphasize important data in a spreadsheet, it's important to be able to Blank______ your information correctly.
format
Naming a range of cells is useful when creating a VLOOKUP.To name a range of cells in Excel, select the range by dragging, then __-click and select Define Name... from the menu.
right
One way to adjust the width of a column quickly in Excel is to place your cursor to the Blank______ of the column heading and just drag.
right side
Entries that Excel recognizes as being able to interact with other cells are referred to as
values
If you wish to drag a value or label across your spreadsheet, use the ___ pointer.
large cross
Placing your cursor between column headings so that you see the double-arrow column-adjusting pointer and then dragging allows you to adjust the width of the column to the ___ of your pointer.
left
The shortcut for adding a column in Excel is to click on the column heading to the right of where you wish to enter the column, and then click CTRL + Shift + Plus (+). Another method is to Blank______ on the heading to the right and select Insert from the context menu.
right-click
To delete a row in Excel, click on any cell in the row and Shift + Spacebar to select the row, then CTRL + Minus (-) to delete it. Alternatively, simply Blank______ on the row heading and select Delete from the context menu.
right-click
When you're using Excel, to hide column D, first click on the column heading to select the column, and then ___ to open the menu and select Hide.
right-click
If you receive an error value of #VALUE! after entering a formula in Excel, then this means that
the operation or function is not possible
Every time you go to the gas station you are amazed by how much prices have increased. At this time last year, the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?
= ((4.25 - 3.20) / 3.20) * 100
A friend asks if you want to go see the new Marvel movie, but you say it is too expensive. "No it is not, tickets have only gone up $2.00 since last year," says your friend. You reply, "Tickets went from $8 to $10 for a matinee. That is a large percentage increase." What formula would provide the percentage increase?
= (10 - 8) / 8 * 100
Placing your cursor between row headings so that you see the double-arrow row-adjusting pointer and then dragging allows you to adjust the height of the row Blank______ your pointer.
above
Select three formatting options that can help to highlight important information in your spreadsheet.
changing fonts, font styles, or font colors creating cell borders. changing alignment in the cell (center, left, top, etc.)
In Excel, the sigma symbol represents the Blank______ function.
AutoSum
Column A shows the value of each sale for the day. If you want cell A37 to display the number of sales, you would use the __ function
COUNT
CTRL + Minus (-) is the shortcut for deleting a row or column in Excel. Using the menu, to delete a row, select the row below where you want to remove a row, the click Home > Cells >
Delete
To remove and replace unwanted characters from an Excel spreadsheet, you will probably want to open the Find & Select menu. This is found in the Editing group on the Blank______ tab.
Home
In Excel, the cell that a user has selected is referred to as the _balnk_ cell.
active
Use the AutoSum function if you want to quickly __ a series of values in a spreadsheet.
add
If you want to find the mean of the values in cells A1, A2, and A3, what function would you place in A4?
AVERAGE
If you want to quickly find the mean of the values in cells A1, A2, and A3, what function would you place in A4?
AVERAGE
What does the formula =SUM(C4,D5) mean in plain language?
Add the numbers in cell C4 and cell D5.
If you enter a formula, and Excel returns an error value of #DIV!, this means that
the formula is dividing a value by zero and therefore cannot enter a result.
Which of the following are methods to Save an Excel file?
Ctrl + S File > Save
To remove the content from one cell and move the content to another cell, one way is to right-click on the origination cell (to open the context menu) and click ___.
Cut
To quickly display the highest number of boxes of cookies purchased by one buyer (column B), use the
MAX
To display the smallest value in a selected range quickly, you could use the Blank______ function.
MIN
Which of the following are methods of selecting a range of adjoining cells in Excel?
Select the first cell in the range and drag down to the last cell. Select the first cell in the range then hold down the Shift key and select the last cell in the range.
Often, when importing content from a different program into Excel, extra blank spaces may be found. An easy way to remove these blank spaces is to use the Blank______ function.
TRIM
To remove trailing blank spaces from imported data sets, one quick method is to use the ___ function.
TRIM
To make important information stand out in a spreadsheet, it's handy to know how to ___ your work.
format
A ___ is a horizontal line of cells in Excel (or any other spreadsheet program).
row
From the following choices, select two methods to Save an Excel file.
File > Save Ctrl + S
