Question

1. Currency is an example of a number format.
   1. TRUE
   2. FALSE
2. To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.
   1. TRUE
   2. FALSE
3. To combine multiple cells into one combined cell, which of the following do you use?
   1. Column Width command
   2. Center button
   3. Merge and Center button
   4. Increase Indent button
4. In formulas, calculations in square brackets are calculated first.
   1. TRUE
   2. FALSE
5. Nathan wants to run a macro from the developer tab. He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run. What should he click as X in this procedure?
   1. Macros
   2. Visual Basic
   3. Record Macro
   4. Macro Security
6. Where do you rename a workbook and adjust its save location?
   1. Save As dialog box
   2. Home tab
   3. Name box
   4. Active cell
7. A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value. In order to do so, he will type the formula =A1-B1 in an empty cell.
   1. TRUE
   2. FALSE
8. Word is unable to publish a blog post document directly to a website.
   1. TRUE
   2. FALSE
9. To create a dashed line around a shape, modify the shape outline style.
   1. TRUE
   2. FALSE

Answer 1

1.True

​​​​

2. True

Yes we can type =SECOND(B1) and

for hour we can type =HOUR(B1)

3. Merge and Center button

4. False

parentheses the part of the formula to be calculated first

5. Macros

6. Save as Dialogue Box

7. True

To do simple subtraction, use the - (minus sign) arithmetic operator.

For example, A1=10 ,B1=5

if you enter the formula =A1-B1 into a cell, the cell will display 5 as the result.

8. False

you can write a post in Word and then publish directly to your WordPress site

9.True

We can modify the shape outline style in Shape Outline

On the Format tab, click the arrow next to Shape Outline.