Question

1. Matthew enters the value 97987 in an Excel, but instead of dispaying this value, Excel display 9.80E+04. What has happened here?

a. The cell does not accept larger values ( greater than 32768)

b. The cell has Fractional formating applied

c. The cell has scientific formating applied

d. The cell has high decimal precison formating applied

e. This is not possible in Excel. Excel will always show the values exactly as you enter them.

2. Susan was able to filter the list of names to only show unique names, by removing all duplicates. How did she do this?

a. She used conditional formatting, by applying the Hidden format on the duplicate cells

b. She selected the list of names, selected copy > paste special, and in the paste special box, checked the skip duplicate box.

c. She used advanced filter to select the list of names, then checked the unique records only checkbox and clicked ok

d. Both B and C are correct

e. This requires a VBA macro, and cannot be done through a command

3. Excel allows you to create new table styles, in addition to those that are provided. The table styles features allow you to control formatting of different elements of a table. Which of the following elements cannot be controlled through a table style?

a. Last row

b. First Column

c. Header Row

d. Footer Row

e. First Total Cell

4. What happens if you provide a negative value to the second parameter (num-digits) of the round () function?

a. A # value returns error is returned

b. A #DIV/0 error is returned

c. For the nun-digits parameter, negative values have the same effect as a 0

d. For the nun-digits parameter, negative values have the same effect as the positive values of quivalent magnitude

e. The number of places to the left decimal of the decimal is rounded up

5. A warning message about the age limit is shown in the Tooltip. The age limit is less than 30. Additionally, you can use that Excel has circled all of the entries that do not fulfill the criteria: Andrew 35, Stephanie 24, Michael 38 and Gayle 28. How can this be achieved?

a. Use the highligh cells rule under conditional formating

b. Use a VBA macro that checks the age for column for invalid entries

c. Use the Advanced filter and specify a Filter criteria

d. Use data validation and specify an input message

e. Use the protect sheet feature

Answer 1

Answer 1
*********
c. The cell has scientific formating applied

see screenshot

Answer 2
*********
c. She used advanced filter to select the list of names, then checked the unique records only checkbox and clicked ok

Answer 3
**********
a. Last row
d. Footer Row
e. First Total Cell

see screenshot

Answer 4
*********
d. For the nun-digits parameter, negative values have the same effect as the positive values of quivalent magnitude

if you have 10.50 and round this number with -1 then answer will be 10 but if you provide -2 then answer will be 0 but if you have the value 100.50 then again answer will be 100 even if argument is -2

Answer 5
*********
d. Use data validation and specify an input message

data validation will display the messeage beside the textbox

if you have any doubt then please ask me without any hesitation in the comment section below , if you like my answer then please thumbs up for the answer , before giving thumbs down please discuss the question it may possible that we may understand the question different way and we can edit and change the answers if you argue, thanks :)