To move to the previous worksheet and
next sheet, what keys will you press?
To move to the previous worksheet, you will use the
keys Ctrl + PgUp, and to move to the next sheet you will use keys Ctrl +
PgDown.
Which function is used to determine
the day of the week for a date?
WEEKDAY () returns the day of the week for a
particular date counting from Sunday.
Example: Let date at A1 be 12/30/2016
WEEKDAY(A1,1) =>6
How can you resize the column?
To resize the column, you should change the width
of one column and then drag the boundary on the right side of the column
heading till the width you want. The other way of doing it is to select the
Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH
under cell section. On clicking on this, the cell size will get formatted.
No comments:
Post a Comment