Lab-5 Quiz-2

Write Your Registration Number

What function in Google Sheets generates a random integer between a specified range?

• =RAND()

• =RANDBETWEEN()

• =RANDOM()

• =ARRAYFORMULA()

Which function generates a random decimal number between 0 and 1 in Google Sheets?

• =RANDOMDECIMAL()

• =RANDBETWEEN()

• =RAND()

• =RANDFLOAT()

To apply a formula across a range of cells in Google Sheets, which function is used?

• =ARRAYFORMULA()

• =MULTIFORMULA()

• =RANDARRAY()

• =SPREADFORMULA()

In Excel, which tab is used to insert charts?

• Home

• Data

• Insert

• View

Which Excel function is commonly used to sort a range of values in random order?

• =SORTBY()

• =RANDARRAY()

• =SORT(A2,RANDARRAY(99),TRUE)

• =RANDBETWEEN()

Which of the following actions will generate new random values in a Google Sheet or Excel file with the RAND or RANDBETWEEN functions?

• Saving the file

• Copying the sheet

• Making any changes to the sheet

• Renaming the file

In Excel, what is the purpose of 'Paste Special'?

• To paste formulas only

• To paste formats only

• To paste values only

• All of the above

How can you ensure data pasted from Excel into PowerPoint updates automatically when changes are made in Excel?

• Use 'Paste as Picture'

• Use 'Paste Special' and select 'Paste Link'

• Use 'Standard Copy-Paste'

• Use 'Drag and Drop'

Which of the following options allows you to copy multiple items and paste them into different locations across Microsoft Office applications?

• Office Clipboard

• Paste Link

• Copy as Picture

• Insert Object