Hear you get Quizzes and Practice Tests, Study Materials, Exam Notifications
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Financial statements, Business forecasting
Transaction registers, inventory control
Accounts receivable, accounts payable
Any of the above
Hyperlink
Index
Transpose
Rows
Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only
Lines and spaces
Layers and planes
Rows and columns
Height and width
Looks up text that contain ‘v’
Checks whether text is the same in one cell as in the next
Finds related records
All of above
Nested
Round
Sum
Text
On the file menu, point to print area, and then click set print area.
On the file menu, click print, and then click selection under print what
On the view menu, click custom views, then click add
Pressing an arrow key
Pressing the tab key
Pressing the Esc key
Clicking the enter button to the formula bar
Pressing the Alt key
Clicking the formula bar
Pressing F2
Double clicking the cell
Pressing the Tab key
Clicking the cell
Printer selection
Vertical or horizontal placement
Orientation
Row and column titles
Range
Scenario
rend line
What-if analysis
Right click on column and select Pick from list
Use data – text to columns menu item
Left click on the gray column title button
Pressing Ctrl + A on the keyboard
Select column D
Select column E
Select columns E, F and G
Select columns D, E, and F.
Select the cells containing the title text and use the fill handle to center
Widen the columns
column width
Row height
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
Split a worksheet into two panes
View different rows and columns
Edit the contents of a cell
View different worksheets
!A!1
$A$1
#a#1
A1
=
+
(
@