DLS-Working Smart with Excel

Which of the following can be used to remove spaces in texts

• TRIM

• VLOOKUP

• SUMIF

• All the above

What is the shortcut for the Go To Dialogue box?

• F7

• F5

• F1

• All the above

which of these functions will give us text in Sentence Case

• RANDARRAY

• TEXT

• PROPER

• None of the above

Which shortcut converts a number to a date format

• ctrl+shift+3

• ctrl+shift+2

• ctrl+shift+7

You can support others in the North East region to have access to an ICT lab by donating to ICT for girls?

• True

• False

Choose the best answer. This month of September is

• Digital Learning Series

• Grow Week and Digital Learning Series

• Learning Month

• All the above