Tech app exam Questions and Answers (100%
Correct Answers) Already Graded A+
Shift— [Ans:] To select adjacent worksheet tabs, click the
first tab, press down and hold down this key, and then
click the last tab.
Ctrl— [Ans:] To select nonadjacent worksheet tabs, click
the first tab, press and hold down this key, and then click
any other tabs you want to select
Source worksheet— [Ans:] When linking data between
worksheets, the worksheet that contains the original data
is called this.
New sheet— [Ans:] Click this button to insert a new
worksheet in a workbook
Tab color— [Ans:] Click this option at the worksheet tab
shortcut menu to apply a color to a worksheet tab
Minimize— [Ans:] Click this button to reduce the active
workbook and display it as a layer behind the Excel button
on the taskbar
Letters— [Ans:] Columns in a worksheet are labeled with
these
Tab— [Ans:] Press this key on the keyboard to move the
insertion point to the next cell.
, AutoFill— [Ans:] This feature automatically inserts words,
numbers, or formulas in a series
Number symbols (####)— [Ans:] If a number entered in a
cell is too long to fit in the cell, it is changed to this.
Merge and center— [Ans:] Click this button to merge
selected cells and center the text within them.
Ctrl— [Ans:] To select nonadjacent columns using the
mouse, press and hold down this key while clicking the
column headers
Numbers— [Ans:] Rows in a worksheet are labeled with
these
Shift + tab— [Ans:] Press this combination of keys on the
keyboard to move the insertion point to the previous cell.
AVERAGE— [Ans:] With this function, a range of cells are
added together and then the total is divided by the
number of cell entries
Data tab, then click on the basic sort using the A-Z
button— [Ans:] Sorting in alphabetical by the first column
which would be the best way to go about this?
Insert— [Ans:] The symbol button is located on this tab
Four-headed arrow— [Ans:] To move an image, position
the mouse pointer on the image border until the mouse
Correct Answers) Already Graded A+
Shift— [Ans:] To select adjacent worksheet tabs, click the
first tab, press down and hold down this key, and then
click the last tab.
Ctrl— [Ans:] To select nonadjacent worksheet tabs, click
the first tab, press and hold down this key, and then click
any other tabs you want to select
Source worksheet— [Ans:] When linking data between
worksheets, the worksheet that contains the original data
is called this.
New sheet— [Ans:] Click this button to insert a new
worksheet in a workbook
Tab color— [Ans:] Click this option at the worksheet tab
shortcut menu to apply a color to a worksheet tab
Minimize— [Ans:] Click this button to reduce the active
workbook and display it as a layer behind the Excel button
on the taskbar
Letters— [Ans:] Columns in a worksheet are labeled with
these
Tab— [Ans:] Press this key on the keyboard to move the
insertion point to the next cell.
, AutoFill— [Ans:] This feature automatically inserts words,
numbers, or formulas in a series
Number symbols (####)— [Ans:] If a number entered in a
cell is too long to fit in the cell, it is changed to this.
Merge and center— [Ans:] Click this button to merge
selected cells and center the text within them.
Ctrl— [Ans:] To select nonadjacent columns using the
mouse, press and hold down this key while clicking the
column headers
Numbers— [Ans:] Rows in a worksheet are labeled with
these
Shift + tab— [Ans:] Press this combination of keys on the
keyboard to move the insertion point to the previous cell.
AVERAGE— [Ans:] With this function, a range of cells are
added together and then the total is divided by the
number of cell entries
Data tab, then click on the basic sort using the A-Z
button— [Ans:] Sorting in alphabetical by the first column
which would be the best way to go about this?
Insert— [Ans:] The symbol button is located on this tab
Four-headed arrow— [Ans:] To move an image, position
the mouse pointer on the image border until the mouse
