MISY 160 EXAM 1 COMPREHENSIVE EXAM QUESTIONS
WITH DETAILED VERIFIED AND 100% ACCURATE
ANSWERS BRAND NEW EXAM ALREADY GRADED A+ PASS
Font color, type, size, fill color, bold, italic and underscore
Ans✓✓✓Setting the format of a cell includes the following:
Font group Ans✓✓✓Font color, font type, font size, fill color, bold,
italic and underscore are all found where on the home tab?
Alignment group Ans✓✓✓Alignment, indent, and merging cells are all
found where in the home tab?
click number format and change places Ans✓✓✓How do you set the
number of decimal places?
Moving, copying, pasting a cell Ans✓✓✓Select the cell you want to
move, hover over the border until the white cross appears, then click,
hold and drag until you get to the destination
Inserting header/footer Ans✓✓✓Page layout tab → Page Setup group
(expand) → Header/Footer
insert file/sheet name in header/footer Ans✓✓✓Page layout tab → Page
Setup group (expand) → custom header/footer → file/sheet icons
, Centering the worksheet horizontally/vertically Ans✓✓✓Page layout
tab → Margins → Custom margins → Center on page
Using formula with cell addresses/references Ans✓✓✓Select the
destination cell, then type = and click the cell addresses to create the
formula
When you don't want cells to shift across Ans✓✓✓When do you lock
the row address?
When you don't want the cells to shift down Ans✓✓✓When do you
lock the column address?
The period (daily, monthly) Ans✓✓✓What do you have to adjust when
you use PMT?
Count is for numbers only, CountA is for anything Ans✓✓✓What is the
difference between COUNT and COUNTA?
VLOOKUP Ans✓✓✓Name the function for the following process:
Searching for a value in the first column of a table and displaying the
result in the same row of a certain column
IF function Ans✓✓✓useful when you want to assign a value to a cell
based on a logical test
WITH DETAILED VERIFIED AND 100% ACCURATE
ANSWERS BRAND NEW EXAM ALREADY GRADED A+ PASS
Font color, type, size, fill color, bold, italic and underscore
Ans✓✓✓Setting the format of a cell includes the following:
Font group Ans✓✓✓Font color, font type, font size, fill color, bold,
italic and underscore are all found where on the home tab?
Alignment group Ans✓✓✓Alignment, indent, and merging cells are all
found where in the home tab?
click number format and change places Ans✓✓✓How do you set the
number of decimal places?
Moving, copying, pasting a cell Ans✓✓✓Select the cell you want to
move, hover over the border until the white cross appears, then click,
hold and drag until you get to the destination
Inserting header/footer Ans✓✓✓Page layout tab → Page Setup group
(expand) → Header/Footer
insert file/sheet name in header/footer Ans✓✓✓Page layout tab → Page
Setup group (expand) → custom header/footer → file/sheet icons
, Centering the worksheet horizontally/vertically Ans✓✓✓Page layout
tab → Margins → Custom margins → Center on page
Using formula with cell addresses/references Ans✓✓✓Select the
destination cell, then type = and click the cell addresses to create the
formula
When you don't want cells to shift across Ans✓✓✓When do you lock
the row address?
When you don't want the cells to shift down Ans✓✓✓When do you
lock the column address?
The period (daily, monthly) Ans✓✓✓What do you have to adjust when
you use PMT?
Count is for numbers only, CountA is for anything Ans✓✓✓What is the
difference between COUNT and COUNTA?
VLOOKUP Ans✓✓✓Name the function for the following process:
Searching for a value in the first column of a table and displaying the
result in the same row of a certain column
IF function Ans✓✓✓useful when you want to assign a value to a cell
based on a logical test
